Remediation scripts/Enable transparent data encryption on SQL databases/PowerShell/Set-Sql-Transparant-Data-Encryption.ps1

param(
    [parameter(Mandatory=$true)]
    [string]$SqlServerName,
    [parameter(Mandatory=$true)]
    [string]$ResourceGroupName,
    [parameter(Mandatory=$true)]
    [string]$DatabaseName
)
$ErrorActionPreference = "Stop"

# Get the current Transparent Data Encryption status
Get-AzSqlDatabaseTransparentDataEncryption -ServerName $SqlServerName -ResourceGroupName $ResourceGroupName -DatabaseName $DatabaseName

# Set the current Transparent Data Encryption status to Enabled
Set-AzSqlDatabaseTransparentDataEncryption -ServerName $SqlServerName -ResourceGroupName $ResourceGroupName -DatabaseName $DatabaseName -State "Enabled"